IF exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[SelectProvincia]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[SelectProvincia]
GO

CREATE PROCEDURE [dbo].[SelectProvincia]
(
	@IdProvincia int
)
AS
BEGIN
	SET NOCOUNT ON

	SELECT
	[IdProvincia],
	[IdDepartamento],
	[Nombre],
	[Estado]
	FROM [Provincia]
	WHERE [IdProvincia] = @IdProvincia

	SET NOCOUNT OFF
END

GO
